Tabela StudyLevel

Definicja tabeli StudyLevel

Name

StudyLevel

Code

StudyLevel

Comment

 


Lista kolumn tabeli StudyLevel

Name

Code

StuDat

StuDat

StuTim

StuTim

AccNum

AccNum

StuID

StuID

StuInsUID

StuInsUID

RefPhyNam

RefPhyNam

StuDes

StuDes

PatAge

PatAge

PatSiz

PatSiz

PatWei

PatWei

NumStuRelSer

NumStuRelSer

NumStuRelIma

NumStuRelIma

InsertDate

InsertDate

InsertTime

InsertTime

Owner

Owner

GroupName

GroupName

Priv

Priv

ArchiveMediaLabel

ArchiveMediaLabel

CompressType

CompressType

BackupStatus

BackupStatus

Availability

Availability

StuCustom1

StuCustom1

StuCustom2

StuCustom2

StuCustom3

StuCustom3

PatNam

PatNam

PatID

PatID

PatBirDat

PatBirDat

PatBirTim

PatBirTim

PatSex

PatSex

NumPatRelStu

NumPatRelStu

NumPatRelSer

NumPatRelSer

NumPatRelIma

NumPatRelIma

PatCustom1

PatCustom1

PatCustom2

PatCustom2

PatCustom3

PatCustom3


Kolumna StuDat tabeli StudyLevel

Definicja kolumny StuDat tabeli StudyLevel

Name

StuDat

Code

StuDat

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StuTim tabeli StudyLevel

Definicja kolumny StuTim tabeli StudyLevel

Name

StuTim

Code

StuTim

Data Type

FLOAT

Mandatory

Yes

Comment

 


Kolumna AccNum tabeli StudyLevel

Definicja kolumny AccNum tabeli StudyLevel

Name

AccNum

Code

AccNum

Data Type

VARCHAR2(16)

Mandatory

Yes

Comment

 


Kolumna StuID tabeli StudyLevel

Definicja kolumny StuID tabeli StudyLevel

Name

StuID

Code

StuID

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna StuInsUID tabeli StudyLevel

Definicja kolumny StuInsUID tabeli StudyLevel

Name

StuInsUID

Code

StuInsUID

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

 


Kolumna RefPhyNam tabeli StudyLevel

Definicja kolumny RefPhyNam tabeli StudyLevel

Name

RefPhyNam

Code

RefPhyNam

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

 


Kolumna StuDes tabeli StudyLevel

Definicja kolumny StuDes tabeli StudyLevel

Name

StuDes

Code

StuDes

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna PatAge tabeli StudyLevel

Definicja kolumny PatAge tabeli StudyLevel

Name

PatAge

Code

PatAge

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna PatSiz tabeli StudyLevel

Definicja kolumny PatSiz tabeli StudyLevel

Name

PatSiz

Code

PatSiz

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna PatWei tabeli StudyLevel

Definicja kolumny PatWei tabeli StudyLevel

Name

PatWei

Code

PatWei

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna NumStuRelSer tabeli StudyLevel

Definicja kolumny NumStuRelSer tabeli StudyLevel

Name

NumStuRelSer

Code

NumStuRelSer

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna NumStuRelIma tabeli StudyLevel

Definicja kolumny NumStuRelIma tabeli StudyLevel

Name

NumStuRelIma

Code

NumStuRelIma

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InsertDate tabeli StudyLevel

Definicja kolumny InsertDate tabeli StudyLevel

Name

InsertDate

Code

InsertDate

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InsertTime tabeli StudyLevel

Definicja kolumny InsertTime tabeli StudyLevel

Name

InsertTime

Code

InsertTime

Data Type

FLOAT

Mandatory

Yes

Comment

 


Kolumna Owner tabeli StudyLevel

Definicja kolumny Owner tabeli StudyLevel

Name

Owner

Code

Owner

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna GroupName tabeli StudyLevel

Definicja kolumny GroupName tabeli StudyLevel

Name

GroupName

Code

GroupName

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna Priv tabeli StudyLevel

Definicja kolumny Priv tabeli StudyLevel

Name

Priv

Code

Priv

Data Type

VARCHAR2(9)

Mandatory

No

Comment

 


Kolumna ArchiveMediaLabel tabeli StudyLevel

Definicja kolumny ArchiveMediaLabel tabeli StudyLevel

Name

ArchiveMediaLabel

Code

ArchiveMediaLabel

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna CompressType tabeli StudyLevel

Definicja kolumny CompressType tabeli StudyLevel

Name

CompressType

Code

CompressType

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BackupStatus tabeli StudyLevel

Definicja kolumny BackupStatus tabeli StudyLevel

Name

BackupStatus

Code

BackupStatus

Data Type

CHAR(1)

Mandatory

No

Comment

 


Kolumna Availability tabeli StudyLevel

Definicja kolumny Availability tabeli StudyLevel

Name

Availability

Code

Availability

Data Type

VARCHAR2(16)

Mandatory

No

Comment

Status dostepnosci badania


Kolumna StuCustom1 tabeli StudyLevel

Definicja kolumny StuCustom1 tabeli StudyLevel

Name

StuCustom1

Code

StuCustom1

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Custom field at study level


Kolumna StuCustom2 tabeli StudyLevel

Definicja kolumny StuCustom2 tabeli StudyLevel

Name

StuCustom2

Code

StuCustom2

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Custom field at study level


Kolumna StuCustom3 tabeli StudyLevel

Definicja kolumny StuCustom3 tabeli StudyLevel

Name

StuCustom3

Code

StuCustom3

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Custom field at study level


Kolumna PatNam tabeli StudyLevel

Definicja kolumny PatNam tabeli StudyLevel

Name

PatNam

Code

PatNam

Data Type

VARCHAR2(128)

Mandatory

Yes

Comment

Nazwisko pacjenta


Kolumna PatID tabeli StudyLevel

Definicja kolumny PatID tabeli StudyLevel

Name

PatID

Code

PatID

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

ID pacjenta


Kolumna PatBirDat tabeli StudyLevel

Definicja kolumny PatBirDat tabeli StudyLevel

Name

PatBirDat

Code

PatBirDat

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Data urodzenia pacjenta


Kolumna PatBirTim tabeli StudyLevel

Definicja kolumny PatBirTim tabeli StudyLevel

Name

PatBirTim

Code

PatBirTim

Data Type

FLOAT

Mandatory

No

Comment

Czas urodzenia pacjenta


Kolumna PatSex tabeli StudyLevel

Definicja kolumny PatSex tabeli StudyLevel

Name

PatSex

Code

PatSex

Data Type

VARCHAR2(16)

Mandatory

Yes

Comment

Plec pacjenta


Kolumna NumPatRelStu tabeli StudyLevel

Definicja kolumny NumPatRelStu tabeli StudyLevel

Name

NumPatRelStu

Code

NumPatRelStu

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Liczba badan pacjenta


Kolumna NumPatRelSer tabeli StudyLevel

Definicja kolumny NumPatRelSer tabeli StudyLevel

Name

NumPatRelSer

Code

NumPatRelSer

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Liczba serii pacjenta


Kolumna NumPatRelIma tabeli StudyLevel

Definicja kolumny NumPatRelIma tabeli StudyLevel

Name

NumPatRelIma

Code

NumPatRelIma

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Liczba obrazów pacjenta


Kolumna PatCustom1 tabeli StudyLevel

Definicja kolumny PatCustom1 tabeli StudyLevel

Name

PatCustom1

Code

PatCustom1

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Custom field at patient level


Kolumna PatCustom2 tabeli StudyLevel

Definicja kolumny PatCustom2 tabeli StudyLevel

Name

PatCustom2

Code

PatCustom2

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Custom field at patient level


Kolumna PatCustom3 tabeli StudyLevel

Definicja kolumny PatCustom3 tabeli StudyLevel

Name

PatCustom3

Code

PatCustom3

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Custom field at patient level


Lista kluczy tabeli StudyLevel

Name

Code

Primary

SL_StuInsUID_index

SL_StuInsUID_index

 


Klucz SL_StuInsUID_index tabeli StudyLevel

Definicja klucza SL_StuInsUID_index tabeli StudyLevel

Name

SL_StuInsUID_index

Code

SL_StuInsUID_index

Primary

No

Comment